Overview

Brought to you by YData

Dataset statistics

Number of variables	33
Number of observations	10324
Missing cells	2383
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	257.0 B

Variable types

Numeric	7
Text	13
Categorical	9
DateTime	3
Boolean	1

Alerts

`line item quantity` is highly overall correlated with `line item insurance (usd)` and 1 other fields	High correlation
`line item value` is highly overall correlated with `line item insurance (usd)` and 1 other fields	High correlation
`line item insurance (usd)` is highly overall correlated with `line item quantity` and 1 other fields	High correlation
`pack price` is highly overall correlated with `brand` and 1 other fields	High correlation
`unit price` is highly overall correlated with `brand` and 1 other fields	High correlation
`brand` is highly overall correlated with `dosage form` and 6 other fields	High correlation
`country` is highly overall correlated with `fulfill via` and 1 other fields	High correlation
`dosage form` is highly overall correlated with `brand` and 3 other fields	High correlation
`fulfill via` is highly overall correlated with `brand` and 3 other fields	High correlation
`id` is highly overall correlated with `fulfill via`	High correlation
`product group` is highly overall correlated with `brand` and 3 other fields	High correlation
`shipment mode` is highly overall correlated with `country`	High correlation
`sub classification` is highly overall correlated with `brand` and 3 other fields	High correlation
`unit of measure (per pack)` is highly overall correlated with `brand` and 3 other fields	High correlation
`vendor inco term` is highly overall correlated with `fulfill via`	High correlation
`managed by` is highly imbalanced (97.4%)	Imbalance
`product group` is highly imbalanced (69.9%)	Imbalance
`brand` is highly imbalanced (62.3%)	Imbalance
`shipment mode` has 360 (3.5%) missing values	Missing
`dosage` has 1736 (16.8%) missing values	Missing
`line item insurance (usd)` has 287 (2.8%) missing values	Missing
`unit price` is highly skewed (γ1 = 40.58484939)	Skewed
`id` has unique values	Unique

Reproduction

Analysis started	2024-12-30 16:45:29.391489
Analysis finished	2024-12-30 16:45:55.755549
Duration	26.36 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

id
Real number (ℝ)

High correlation Unique

Distinct	10324
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51098.968

Minimum	1
Maximum	86823
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	5151.2
Q1	12795.75
median	57540.5
Q3	83648.25
95-th percentile	86167.85
Maximum	86823
Range	86822
Interquartile range (IQR)	70852.5

Descriptive statistics

Standard deviation	31944.332
Coefficient of variation (CV)	0.62514633
Kurtosis	-1.6398372
Mean	51098.968
Median Absolute Deviation (MAD)	27404
Skewness	-0.23036671
Sum	5.2754575 × 10⁸
Variance	1.0204404 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
82565	1	< 0.1%
82594	1	< 0.1%
82595	1	< 0.1%
82596	1	< 0.1%
82597	1	< 0.1%
82599	1	< 0.1%
82600	1	< 0.1%
82601	1	< 0.1%
82602	1	< 0.1%
Other values (10314)	10314	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
23	1	< 0.1%
44	1	< 0.1%
45	1	< 0.1%
46	1	< 0.1%
47	1	< 0.1%

Value	Count	Frequency (%)
86823	1	< 0.1%
86822	1	< 0.1%
86821	1	< 0.1%
86819	1	< 0.1%
86818	1	< 0.1%
86817	1	< 0.1%
86816	1	< 0.1%
86815	1	< 0.1%
86814	1	< 0.1%
86813	1	< 0.1%

project code
Text

Distinct	142
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	103240
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	100-CI-T01
2nd row	108-VN-T01
3rd row	100-CI-T01
4th row	108-VN-T01
5th row	108-VN-T01

Value	Count	Frequency (%)
116-za-t30	768	7.4%
104-ci-t30	729	7.1%
151-ng-t30	628	6.1%
114-ug-t30	596	5.8%
108-vn-t30	522	5.1%
106-ht-t30	450	4.4%
111-mz-t30	431	4.2%
110-zm-t30	406	3.9%
109-tz-t30	369	3.6%
107-rw-t30	340	3.3%
Other values (132)	5085	49.3%

Most occurring characters

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	103240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20648	20.0%
1	18694	18.1%
0	16409	15.9%
T	11732	11.4%
3	8596	8.3%
Z	3815	3.7%
G	2289	2.2%
6	2032	2.0%
N	1981	1.9%
4	1852	1.8%
Other values (25)	15192	14.7%

pq #
Text

Distinct	1237
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	14
Median length	9
Mean length	9.9468229
Min length	8

Characters and Unicode

Total characters	102691
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	380 ?
Unique (%)	3.7%

Sample

1st row	Pre-PQ Process
2nd row	Pre-PQ Process
3rd row	Pre-PQ Process
4th row	Pre-PQ Process
5th row	Pre-PQ Process

Value	Count	Frequency (%)
pre-pq	2681	20.6%
process	2681	20.6%
fpq-14942	205	1.6%
fpq-12522	154	1.2%
fpq-13973	110	0.8%
fpq-4537	98	0.8%
fpq-8840	90	0.7%
fpq-7175	78	0.6%
fpq-5303	78	0.6%
fpq-6262	75	0.6%
Other values (1228)	6755	51.9%

Most occurring characters

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	102691	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	102691	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	102691	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	15686	15.3%
Q	10324	10.1%
-	10324	10.1%
F	7643	7.4%
1	6503	6.3%
s	5362	5.2%
e	5362	5.2%
r	5362	5.2%
2	3851	3.8%
4	3824	3.7%
Other values (10)	28450	27.7%

po / so #
Text

Distinct	6233
Distinct (%)	60.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	11
Median length	10
Mean length	9.0565672
Min length	6

Characters and Unicode

Total characters	93500
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4540 ?
Unique (%)	44.0%

Sample

1st row	SCMS-4
2nd row	SCMS-13
3rd row	SCMS-20
4th row	SCMS-78
5th row	SCMS-81

Value	Count	Frequency (%)
scms-199289	67	0.6%
scms-199283	63	0.6%
scms-183950	55	0.5%
scms-259075	38	0.4%
scms-215370	38	0.4%
scms-259079	33	0.3%
scms-23500	26	0.3%
scms-215410	26	0.3%
scms-259078	20	0.2%
scms-162440	20	0.2%
Other values (6223)	9938	96.3%

Most occurring characters

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	93500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	93500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	93500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	15243	16.3%
-	10324	11.0%
0	10280	11.0%
1	6433	6.9%
4	6052	6.5%
2	5714	6.1%
3	5482	5.9%
O	5404	5.8%
C	4920	5.3%
M	4920	5.3%
Other values (6)	18728	20.0%

asn/dn #
Text

Distinct	7030
Distinct (%)	68.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	9
Median length	8
Mean length	7.6271794
Min length	4

Characters and Unicode

Total characters	78743
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5580 ?
Unique (%)	54.0%

Sample

1st row	ASN-8
2nd row	ASN-85
3rd row	ASN-14
4th row	ASN-50
5th row	ASN-55

Value	Count	Frequency (%)
asn-19166	54	0.5%
asn-24415	38	0.4%
asn-23875	26	0.3%
asn-32138	19	0.2%
asn-28036	17	0.2%
asn-28034	17	0.2%
dn-304	17	0.2%
asn-28033	17	0.2%
asn-30792	17	0.2%
asn-1520	16	0.2%
Other values (7020)	10086	97.7%

Most occurring characters

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	78743	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	78743	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	78743	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	10324	13.1%
-	10324	13.1%
2	6558	8.3%
1	6137	7.8%
3	5629	7.1%
D	5404	6.9%
A	4920	6.2%
S	4920	6.2%
4	3911	5.0%
7	3586	4.6%
Other values (5)	17030	21.6%

country
Categorical

High correlation

Distinct	43
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

South Africa	1406
Nigeria	1194
Côte d'Ivoire	1083
Uganda	779
Vietnam	688
Other values (38)	5174

Length

Max length	18
Median length	12
Mean length	8.4762689
Min length	4

Characters and Unicode

Total characters	87509
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Côte d'Ivoire
2nd row	Vietnam
3rd row	Côte d'Ivoire
4th row	Vietnam
5th row	Vietnam

Common Values

Value	Count	Frequency (%)
South Africa	1406	13.6%
Nigeria	1194	11.6%
Côte d'Ivoire	1083	10.5%
Uganda	779	7.5%
Vietnam	688	6.7%
Zambia	683	6.6%
Haiti	655	6.3%
Mozambique	631	6.1%
Zimbabwe	538	5.2%
Tanzania	519	5.0%
Other values (33)	2148	20.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
south	1570	11.7%
africa	1406	10.5%
nigeria	1194	8.9%
côte	1083	8.1%
d'ivoire	1083	8.1%
uganda	779	5.8%
vietnam	688	5.1%
zambia	683	5.1%
haiti	655	4.9%
mozambique	631	4.7%
Other values (38)	3596	26.9%

Most occurring characters

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87509	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	12282	14.0%
i	10247	11.7%
e	5522	6.3%
o	4473	5.1%
n	4350	5.0%
t	4323	4.9%
r	3874	4.4%
	3044	3.5%
u	2914	3.3%
m	2777	3.2%
Other values (38)	33703	38.5%

managed by
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

PMO - US	10265
South Africa Field Office	57
Haiti Field Office	1
Ethiopia Field Office	1

Length

Max length	25
Median length	8
Mean length	8.0960868
Min length	8

Characters and Unicode

Total characters	83584
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	PMO - US
2nd row	PMO - US
3rd row	PMO - US
4th row	PMO - US
5th row	PMO - US

Common Values

Value	Count	Frequency (%)
PMO - US	10265	99.4%
South Africa Field Office	57	0.6%
Haiti Field Office	1	< 0.1%
Ethiopia Field Office	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pmo	10265	33.1%
	10265	33.1%
us	10265	33.1%
field	59	0.2%
office	59	0.2%
south	57	0.2%
africa	57	0.2%
haiti	1	< 0.1%
ethiopia	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	83584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	20705	24.8%
O	10324	12.4%
S	10322	12.3%
P	10265	12.3%
M	10265	12.3%
-	10265	12.3%
U	10265	12.3%
i	179	0.2%
f	175	0.2%
e	118	0.1%
Other values (14)	701	0.8%

fulfill via
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

From RDC	5404
Direct Drop	4920

Length

Max length	11
Median length	8
Mean length	9.4296784
Min length	8

Characters and Unicode

Total characters	97352
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct Drop
2nd row	Direct Drop
3rd row	Direct Drop
4th row	Direct Drop
5th row	Direct Drop

Common Values

Value	Count	Frequency (%)
From RDC	5404	52.3%
Direct Drop	4920	47.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
from	5404	26.2%
rdc	5404	26.2%
direct	4920	23.8%
drop	4920	23.8%

Most occurring characters

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	97352	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	15244	15.7%
D	15244	15.7%
o	10324	10.6%
	10324	10.6%
F	5404	5.6%
m	5404	5.6%
R	5404	5.6%
C	5404	5.6%
i	4920	5.1%
e	4920	5.1%
Other values (3)	14760	15.2%

vendor inco term
Categorical

High correlation

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

N/A - From RDC	5404
EXW	2778
DDP	1443
FCA	397
CIP	275
Other values (3)	27

Length

Max length	14
Median length	14
Mean length	8.7578458
Min length	3

Characters and Unicode

Total characters	90416
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EXW
2nd row	EXW
3rd row	FCA
4th row	EXW
5th row	EXW

Common Values

Value	Count	Frequency (%)
N/A - From RDC	5404	52.3%
EXW	2778	26.9%
DDP	1443	14.0%
FCA	397	3.8%
CIP	275	2.7%
DDU	15	0.1%
DAP	9	0.1%
CIF	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n/a	5404	20.4%
	5404	20.4%
from	5404	20.4%
rdc	5404	20.4%
exw	2778	10.5%
ddp	1443	5.4%
fca	397	1.5%
cip	275	1.0%
ddu	15	0.1%
dap	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	90416	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	16212	17.9%
D	8329	9.2%
C	6079	6.7%
A	5810	6.4%
F	5804	6.4%
N	5404	6.0%
m	5404	6.0%
/	5404	6.0%
R	5404	6.0%
o	5404	6.0%
Other values (8)	21162	23.4%

shipment mode
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	360
Missing (%)	3.5%
Memory size	80.8 KiB

Air	6113
Truck	2830
Air Charter	650
Ocean	371

Length

Max length	11
Median length	3
Mean length	4.1643918
Min length	3

Characters and Unicode

Total characters	41494
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Air
2nd row	Air
3rd row	Air
4th row	Air
5th row	Air

Common Values

Value	Count	Frequency (%)
Air	6113	59.2%
Truck	2830	27.4%
Air Charter	650	6.3%
Ocean	371	3.6%
(Missing)	360	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
air	6763	63.7%
truck	2830	26.7%
charter	650	6.1%
ocean	371	3.5%

Most occurring characters

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41494	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41494	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41494	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	10893	26.3%
A	6763	16.3%
i	6763	16.3%
c	3201	7.7%
T	2830	6.8%
u	2830	6.8%
k	2830	6.8%
a	1021	2.5%
e	1021	2.5%
	650	1.6%
Other values (5)	2692	6.5%

pq first sent to client date
Text

Distinct	765
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	17
Median length	14
Mean length	10.355579
Min length	8

Characters and Unicode

Total characters	106911
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	133 ?
Unique (%)	1.3%

Sample

1st row	Pre-PQ Process
2nd row	Pre-PQ Process
3rd row	Pre-PQ Process
4th row	Pre-PQ Process
5th row	Pre-PQ Process

Value	Count	Frequency (%)
pre-pq	2476	18.7%
process	2476	18.7%
9/11/2014	205	1.6%
date	205	1.6%
not	205	1.6%
captured	205	1.6%
7/11/2013	173	1.3%
4/30/2014	123	0.9%
11/6/2009	98	0.7%
11/21/2011	90	0.7%
Other values (758)	6954	52.6%

Most occurring characters

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	106911	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	106911	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	106911	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	15328	14.3%
/	15286	14.3%
2	12611	11.8%
0	11326	10.6%
P	7428	6.9%
e	5362	5.0%
r	5157	4.8%
s	4952	4.6%
3	3479	3.3%
4	2986	2.8%
Other values (18)	22996	21.5%

po sent to vendor date
Text

Distinct	897
Distinct (%)	8.7%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	17
Median length	14
Mean length	11.849961
Min length	8

Characters and Unicode

Total characters	122339
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	256 ?
Unique (%)	2.5%

Sample

1st row	Date Not Captured
2nd row	Date Not Captured
3rd row	Date Not Captured
4th row	Date Not Captured
5th row	Date Not Captured

Value	Count	Frequency (%)
n/a	5404	19.9%
	5404	19.9%
from	5404	19.9%
rdc	5404	19.9%
date	328	1.2%
not	328	1.2%
captured	328	1.2%
8/27/2014	80	0.3%
3/19/2010	78	0.3%
8/29/2014	76	0.3%
Other values (892)	4358	16.0%

Most occurring characters

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122339	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122339	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122339	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	16868	13.8%
/	14588	11.9%
2	7921	6.5%
1	7602	6.2%
0	7063	5.8%
o	5732	4.7%
D	5732	4.7%
N	5732	4.7%
r	5732	4.7%
C	5732	4.7%
Other values (18)	39637	32.4%

scheduled delivery date
Date

Distinct	2006
Distinct (%)	19.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Minimum	2006-05-02 00:00:00
Maximum	2015-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

delivered to client date
Date

Distinct	2093
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Minimum	2006-05-02 00:00:00
Maximum	2015-09-14 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

delivery recorded date
Date

Distinct	2042
Distinct (%)	19.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Minimum	2006-05-02 00:00:00
Maximum	2015-09-14 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

product group
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

ARV	8550
HRDT	1728
ANTM	22
ACT	16
MRDT	8

Length

Max length	4
Median length	3
Mean length	3.1702828
Min length	3

Characters and Unicode

Total characters	32730
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HRDT
2nd row	ARV
3rd row	HRDT
4th row	ARV
5th row	ARV

Common Values

Value	Count	Frequency (%)
ARV	8550	82.8%
HRDT	1728	16.7%
ANTM	22	0.2%
ACT	16	0.2%
MRDT	8	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
arv	8550	82.8%
hrdt	1728	16.7%
antm	22	0.2%
act	16	0.2%
mrdt	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32730	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	10286	31.4%
A	8588	26.2%
V	8550	26.1%
T	1774	5.4%
D	1736	5.3%
H	1728	5.3%
M	30	0.1%
N	22	0.1%
C	16	< 0.1%

sub classification
Categorical

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Adult	6595
Pediatric	1955
HIV test	1567
HIV test - Ancillary	161
Malaria	30

Length

Max length	20
Median length	5
Mean length	6.4494382
Min length	3

Characters and Unicode

Total characters	66584
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HIV test
2nd row	Pediatric
3rd row	HIV test
4th row	Adult
5th row	Adult

Common Values

Value	Count	Frequency (%)
Adult	6595	63.9%
Pediatric	1955	18.9%
HIV test	1567	15.2%
HIV test - Ancillary	161	1.6%
Malaria	30	0.3%
ACT	16	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
adult	6595	53.3%
pediatric	1955	15.8%
hiv	1728	14.0%
test	1728	14.0%
	161	1.3%
ancillary	161	1.3%
malaria	30	0.2%
act	16	0.1%

Most occurring characters

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	66584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	12006	18.0%
d	8550	12.8%
l	6947	10.4%
A	6772	10.2%
u	6595	9.9%
i	4101	6.2%
e	3683	5.5%
a	2206	3.3%
r	2146	3.2%
c	2116	3.2%
Other values (12)	11462	17.2%

vendor
Text

Distinct	73
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	65
Median length	13
Mean length	18.53332
Min length	7

Characters and Unicode

Total characters	191338
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.2%

Sample

1st row	RANBAXY Fine Chemicals LTD.
2nd row	Aurobindo Pharma Limited
3rd row	Abbott GmbH & Co. KG
4th row	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)
5th row	Aurobindo Pharma Limited

Value	Count	Frequency (%)
scms	5404	16.5%
rdc	5404	16.5%
from	5404	16.5%
limited	1288	3.9%
ltd	1169	3.6%
orgenics	754	2.3%
s	717	2.2%
buys	715	2.2%
wholesaler	715	2.2%
laboratories	705	2.2%
Other values (158)	10470	32.0%

Most occurring characters

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	191338	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	22491	11.8%
S	16965	8.9%
C	13420	7.0%
R	11481	6.0%
M	8653	4.5%
r	8112	4.2%
D	7485	3.9%
o	7434	3.9%
L	7380	3.9%
m	6798	3.6%
Other values (44)	81119	42.4%

item description
Text

Distinct	184
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	113
Median length	79
Mean length	50.144808
Min length	31

Characters and Unicode

Total characters	517695
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	0.2%

Sample

1st row	HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests
2nd row	Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml
3rd row	HIV 1/2, Determine Complete HIV Kit, 100 Tests
4th row	Lamivudine 150mg, tablets, 60 Tabs
5th row	Stavudine 30mg, capsules, 60 Caps

Value	Count	Frequency (%)
tablets	6733	10.3%
tabs	6711	10.2%
60	4269	6.5%
hiv	3006	4.6%
30	2598	4.0%
tests	1616	2.5%
kit	1579	2.4%
1/2	1524	2.3%
disoproxil	1300	2.0%
fumarate	1300	2.0%
Other values (289)	34956	53.3%

Most occurring characters

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	517695	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	517695	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	517695	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	55268	10.7%
i	33699	6.5%
a	33528	6.5%
0	33249	6.4%
e	33073	6.4%
t	26685	5.2%
s	24970	4.8%
,	22576	4.4%
l	17483	3.4%
n	17399	3.4%
Other values (63)	219765	42.5%

molecule/test type
Text

Distinct	86
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	98
Median length	60
Mean length	22.15091
Min length	7

Characters and Unicode

Total characters	228686
Distinct characters	63
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	0.1%

Sample

1st row	HIV, Reveal G3 Rapid HIV-1 Antibody Test
2nd row	Nevirapine
3rd row	HIV 1/2, Determine Complete HIV Kit
4th row	Lamivudine
5th row	Stavudine

Value	Count	Frequency (%)
hiv	3055	13.6%
kit	1579	7.0%
1/2	1524	6.8%
disoproxil	1300	5.8%
fumarate	1300	5.8%
efavirenz	1125	5.0%
nevirapine	877	3.9%
determine	799	3.6%
lamivudine/nevirapine/zidovudine	707	3.2%
lamivudine/zidovudine	689	3.1%
Other values (148)	9451	42.2%

Most occurring characters

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	228686	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	30297	13.2%
e	19499	8.5%
a	15535	6.8%
n	15469	6.8%
v	13084	5.7%
	12082	5.3%
r	11537	5.0%
o	10997	4.8%
d	9170	4.0%
t	8291	3.6%
Other values (53)	82725	36.2%

brand
Categorical

High correlation Imbalance

Distinct	48
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Generic	7285
Determine	799
Uni-Gold	373
Aluvia	250
Kaletra	165
Other values (43)	1452

Length

Max length	15
Median length	7
Mean length	7.2879698
Min length	3

Characters and Unicode

Total characters	75241
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Reveal
2nd row	Generic
3rd row	Determine
4th row	Generic
5th row	Generic

Common Values

Value	Count	Frequency (%)
Generic	7285	70.6%
Determine	799	7.7%
Uni-Gold	373	3.6%
Aluvia	250	2.4%
Kaletra	165	1.6%
Norvir	136	1.3%
Stat-Pak	115	1.1%
Bioline	113	1.1%
Truvada	94	0.9%
Videx	84	0.8%
Other values (38)	910	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
generic	7285	69.7%
determine	799	7.6%
uni-gold	373	3.6%
aluvia	250	2.4%
kaletra	165	1.6%
norvir	136	1.3%
videx	125	1.2%
stat-pak	115	1.1%
bioline	113	1.1%
truvada	94	0.9%
Other values (40)	995	9.5%

Most occurring characters

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	75241	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	18044	24.0%
i	10118	13.4%
r	9288	12.3%
n	8958	11.9%
G	7758	10.3%
c	7463	9.9%
t	1628	2.2%
a	1599	2.1%
l	1331	1.8%
o	991	1.3%
Other values (38)	8063	10.7%

dosage
Text

Missing

Distinct	54
Distinct (%)	0.6%
Missing	1736
Missing (%)	16.8%
Memory size	80.8 KiB

Length

Max length	15
Median length	13
Mean length	7.3544481
Min length	2

Characters and Unicode

Total characters	63160
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	10mg/ml
2nd row	150mg
3rd row	30mg
4th row	10mg/ml
5th row	200mg

Value	Count	Frequency (%)
300mg	990	11.5%
200mg	932	10.9%
600mg	772	9.0%
150/300mg	600	7.0%
150/300/200mg	580	6.8%
10mg/ml	552	6.4%
150mg	431	5.0%
200/50mg	395	4.6%
300/300mg	301	3.5%
600/300/300mg	286	3.3%
Other values (44)	2749	32.0%

Most occurring characters

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	63160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	63160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	63160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21765	34.5%
m	9548	15.1%
g	8596	13.6%
/	6117	9.7%
3	4855	7.7%
2	3187	5.0%
1	3098	4.9%
5	3045	4.8%
6	1613	2.6%
l	964	1.5%
Other values (4)	372	0.6%

dosage form
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Tablet	3532
Tablet - FDC	2749
Test kit	1575
Capsule	729
Oral solution	727
Other values (12)	1012

Length

Max length	34
Median length	33
Mean length	10.253584
Min length	6

Characters and Unicode

Total characters	105858
Distinct characters	32
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Test kit
2nd row	Oral suspension
3rd row	Test kit
4th row	Tablet
5th row	Capsule

Common Values

Value	Count	Frequency (%)
Tablet	3532	34.2%
Tablet - FDC	2749	26.6%
Test kit	1575	15.3%
Capsule	729	7.1%
Oral solution	727	7.0%
Chewable/dispersible tablet - FDC	239	2.3%
Oral suspension	214	2.1%
Test kit - Ancillary	161	1.6%
Chewable/dispersible tablet	146	1.4%
Delayed-release capsules	131	1.3%
Other values (7)	121	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tablet	6711	33.3%
	3270	16.2%
fdc	3023	15.0%
test	1736	8.6%
kit	1736	8.6%
oral	970	4.8%
solution	755	3.7%
capsule	729	3.6%
chewable/dispersible	385	1.9%
suspension	214	1.1%
Other values (8)	654	3.2%

Most occurring characters

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	105858	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	12083	11.4%
t	11415	10.8%
l	10859	10.3%
	9859	9.3%
a	9472	8.9%
T	8062	7.6%
b	7567	7.1%
s	5234	4.9%
C	4137	3.9%
i	3728	3.5%
Other values (22)	23442	22.1%

unit of measure (per pack)
Real number (ℝ)

High correlation

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.990895

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	30
median	60
Q3	90
95-th percentile	240
Maximum	1000
Range	999
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	76.579764
Coefficient of variation (CV)	0.98190646
Kurtosis	36.093999
Mean	77.990895
Median Absolute Deviation (MAD)	30
Skewness	4.3025025
Sum	805178
Variance	5864.4602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
60	4121	39.9%
30	2630	25.5%
100	976	9.5%
240	670	6.5%
120	474	4.6%
20	470	4.6%
90	222	2.2%
300	157	1.5%
1	126	1.2%
25	114	1.1%
Other values (21)	364	3.5%

Value	Count	Frequency (%)
1	126	1.2%
2	4	< 0.1%
3	8	0.1%
5	4	< 0.1%
12	2	< 0.1%
18	4	< 0.1%
20	470	4.6%
24	2	< 0.1%
25	114	1.1%
30	2630	25.5%

Value	Count	Frequency (%)
1000	16	0.2%
720	5	< 0.1%
540	7	0.1%
336	39	0.4%
300	157	1.5%
270	53	0.5%
240	670	6.5%
200	76	0.7%
180	76	0.7%
168	3	< 0.1%

line item quantity
Real number (ℝ)

High correlation

Distinct	5065
Distinct (%)	49.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18332.535

Minimum	1
Maximum	619999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	408
median	3000
Q3	17039.75
95-th percentile	90951.55
Maximum	619999
Range	619998
Interquartile range (IQR)	16631.75

Descriptive statistics

Standard deviation	40035.303
Coefficient of variation (CV)	2.1838389
Kurtosis	40.0503
Mean	18332.535
Median Absolute Deviation (MAD)	2950
Skewness	5.0383147
Sum	1.8926509 × 10⁸
Variance	1.6028255 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	93	0.9%
1000	91	0.9%
100	87	0.8%
2000	73	0.7%
5000	69	0.7%
500	67	0.6%
20000	67	0.6%
3000	66	0.6%
3	63	0.6%
50000	62	0.6%
Other values (5055)	9586	92.9%

Value	Count	Frequency (%)
1	35	0.3%
2	40	0.4%
3	63	0.6%
4	46	0.4%
5	28	0.3%
6	48	0.5%
7	27	0.3%
8	26	0.3%
9	22	0.2%
10	54	0.5%

Value	Count	Frequency (%)
619999	1	< 0.1%
600906	1	< 0.1%
555197	1	< 0.1%
515000	3	< 0.1%
514526	1	< 0.1%
460041	1	< 0.1%
440000	1	< 0.1%
438409	1	< 0.1%
401961	1	< 0.1%
400000	2	< 0.1%

line item value
Real number (ℝ)

High correlation

Distinct	8741
Distinct (%)	84.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	157650.57

Minimum	0
Maximum	5951990.4
Zeros	17
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	192.5755
Q1	4314.5925
median	30471.465
Q3	166447.14
95-th percentile	702831
Maximum	5951990.4
Range	5951990.4
Interquartile range (IQR)	162132.55

Descriptive statistics

Standard deviation	345292.07
Coefficient of variation (CV)	2.1902368
Kurtosis	54.15243
Mean	157650.57
Median Absolute Deviation (MAD)	29920.465
Skewness	5.8370202
Sum	1.6275845 × 10⁹
Variance	1.1922661 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200000	29	0.3%
16000	23	0.2%
800	18	0.2%
0	17	0.2%
14400	16	0.2%
3200	15	0.1%
244216	15	0.1%
120000	13	0.1%
160	11	0.1%
250	11	0.1%
Other values (8731)	10156	98.4%

Value	Count	Frequency (%)
0	17	0.2%
0.01	1	< 0.1%
0.03	1	< 0.1%
0.12	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.42	1	< 0.1%
0.5	1	< 0.1%
0.7	1	< 0.1%

Value	Count	Frequency (%)
5951990.4	1	< 0.1%
5768697.6	1	< 0.1%
5329891.2	1	< 0.1%
5140114.74	1	< 0.1%
4959241.98	1	< 0.1%
4278871.84	1	< 0.1%
4228629.72	1	< 0.1%
4014000	1	< 0.1%
3932880	1	< 0.1%
3904000	2	< 0.1%

pack price
Real number (ℝ)

High correlation

Distinct	1175
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.910241

Minimum	0
Maximum	1345.64
Zeros	18
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.9
Q1	4.12
median	9.3
Q3	23.5925
95-th percentile	80
Maximum	1345.64
Range	1345.64
Interquartile range (IQR)	19.4725

Descriptive statistics

Standard deviation	45.609223
Coefficient of variation (CV)	2.0816395
Kurtosis	293.1762
Mean	21.910241
Median Absolute Deviation (MAD)	6.57
Skewness	12.988432
Sum	226201.33
Variance	2080.2012
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	368	3.6%
80	307	3.0%
89	183	1.8%
11.22	139	1.3%
20	110	1.1%
1.95	91	0.9%
8.76	91	0.9%
2.44	90	0.9%
2.1	89	0.9%
2.26	88	0.9%
Other values (1165)	8768	84.9%

Value	Count	Frequency (%)
0	18	0.2%
0.01	85	0.8%
0.39	2	< 0.1%
0.7	2	< 0.1%
0.9	4	< 0.1%
1.1	2	< 0.1%
1.14	2	< 0.1%
1.17	1	< 0.1%
1.2	1	< 0.1%
1.21	1	< 0.1%

Value	Count	Frequency (%)
1345.64	1	< 0.1%
1250	1	< 0.1%
1242.53	3	< 0.1%
750.29	1	< 0.1%
700	1	< 0.1%
400	9	0.1%
350	39	0.4%
308.17	3	< 0.1%
306.88	3	< 0.1%
301.53	1	< 0.1%

unit price
Real number (ℝ)

High correlation Skewed

Distinct	183
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.61170089

Minimum	0
Maximum	238.65
Zeros	103
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01
Q1	0.08
median	0.16
Q3	0.47
95-th percentile	1.6
Maximum	238.65
Range	238.65
Interquartile range (IQR)	0.39

Descriptive statistics

Standard deviation	3.2758077
Coefficient of variation (CV)	5.3552443
Kurtosis	2725.9603
Mean	0.61170089
Median Absolute Deviation (MAD)	0.12
Skewness	40.584849
Sum	6315.2
Variance	10.730916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.04	713	6.9%
0.01	492	4.8%
0.12	464	4.5%
0.14	444	4.3%
0.8	411	4.0%
0.11	400	3.9%
1.6	368	3.6%
0.05	343	3.3%
0.16	343	3.3%
0.19	321	3.1%
Other values (173)	6025	58.4%

Value	Count	Frequency (%)
0	103	1.0%
0.01	492	4.8%
0.02	140	1.4%
0.03	250	2.4%
0.04	713	6.9%
0.05	343	3.3%
0.06	274	2.7%
0.07	248	2.4%
0.08	146	1.4%
0.09	154	1.5%

Value	Count	Frequency (%)
238.65	1	< 0.1%
41.68	1	< 0.1%
37.5	2	< 0.1%
30	1	< 0.1%
26.91	1	< 0.1%
25	4	< 0.1%
24.85	3	< 0.1%
24.5	46	0.4%
23	23	0.2%
17.12	3	< 0.1%

manufacturing site
Text

Distinct	88
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	72
Median length	37
Mean length	25.039132
Min length	5

Characters and Unicode

Total characters	258504
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	0.2%

Sample

1st row	Ranbaxy Fine Chemicals LTD
2nd row	Aurobindo Unit III, India
3rd row	ABBVIE GmbH & Co.KG Wiesbaden
4th row	Ranbaxy, Paonta Shahib, India
5th row	Aurobindo Unit III, India

Value	Count	Frequency (%)
india	4678	11.9%
unit	4197	10.7%
iii	4041	10.3%
aurobindo	3283	8.4%
mylan	1438	3.7%
formerly	1415	3.6%
matrix	1415	3.6%
nashik	1415	3.6%
in	1047	2.7%
hetero	913	2.3%
Other values (201)	15396	39.2%

Most occurring characters

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	258504	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	28937	11.2%
i	20789	8.0%
I	19607	7.6%
a	18921	7.3%
n	18236	7.1%
r	13636	5.3%
o	12958	5.0%
d	12314	4.8%
e	10570	4.1%
t	10195	3.9%
Other values (59)	92341	35.7%

first line designation
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

True	7030
False	3294

Value	Count	Frequency (%)
True	7030	68.1%
False	3294	31.9%

weight (kilograms)
Text

Distinct	4688
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	26
Median length	24
Mean length	11.359163
Min length	1

Characters and Unicode

Total characters	117272
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3014 ?
Unique (%)	29.2%

Sample

1st row	13
2nd row	358
3rd row	171
4th row	1855
5th row	7590

Value	Count	Frequency (%)
see	2445	13.4%
weight	1507	8.3%
separately	1507	8.3%
captured	1507	8.3%
2	29	0.2%
6	26	0.1%
1	23	0.1%
5	20	0.1%
60	20	0.1%
4	19	0.1%
Other values (5980)	11125	61.0%

Most occurring characters

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	117272	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	117272	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	117272	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10918	9.3%
	7904	6.7%
1	6455	5.5%
2	5833	5.0%
3	5113	4.4%
8	4534	3.9%
t	4521	3.9%
a	4521	3.9%
S	4460	3.8%
D	4382	3.7%
Other values (25)	58631	50.0%

freight cost (usd)
Text

Distinct	6733
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Memory size	80.8 KiB

Length

Max length	34
Median length	24
Mean length	14.795234
Min length	2

Characters and Unicode

Total characters	152746
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5849 ?
Unique (%)	56.7%

Sample

1st row	780.34
2nd row	4521.5
3rd row	1653.78
4th row	16007.06
5th row	45450.08

Value	Count	Frequency (%)
see	2445	11.5%
freight	1442	6.8%
in	1442	6.8%
commodity	1442	6.8%
cost	1442	6.8%
included	1442	6.8%
invoiced	239	1.1%
separately	239	1.1%
9736.1	36	0.2%
6147.18	27	0.1%
Other values (8028)	11025	52.0%

Most occurring characters

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	152746	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	152746	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	152746	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	10897	7.1%
e	8491	5.6%
1	8391	5.5%
2	7344	4.8%
3	6673	4.4%
8	6162	4.0%
.	5734	3.8%
4	5646	3.7%
5	5346	3.5%
6	5136	3.4%
Other values (32)	82926	54.3%

line item insurance (usd)
Real number (ℝ)

High correlation Missing

Distinct	6722
Distinct (%)	67.0%
Missing	287
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	240.11763

Minimum	0
Maximum	7708.44
Zeros	54
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.25
Q1	6.51
median	47.04
Q3	252.4
95-th percentile	1082.032
Maximum	7708.44
Range	7708.44
Interquartile range (IQR)	245.89

Descriptive statistics

Standard deviation	500.19057
Coefficient of variation (CV)	2.0831064
Kurtosis	34.911215
Mean	240.11763
Median Absolute Deviation (MAD)	46.27
Skewness	4.8271624
Sum	2410060.6
Variance	250190.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	54	0.5%
0.02	37	0.4%
0.07	33	0.3%
0.05	30	0.3%
0.06	30	0.3%
0.01	26	0.3%
0.03	23	0.2%
0.09	21	0.2%
0.08	20	0.2%
0.49	18	0.2%
Other values (6712)	9745	94.4%
(Missing)	287	2.8%

Value	Count	Frequency (%)
0	54	0.5%
0.01	26	0.3%
0.02	37	0.4%
0.03	23	0.2%
0.04	14	0.1%
0.05	30	0.3%
0.06	30	0.3%
0.07	33	0.3%
0.08	20	0.2%
0.09	21	0.2%

Value	Count	Frequency (%)
7708.44	1	< 0.1%
7005.49	1	< 0.1%
5930.22	1	< 0.1%
5573.31	1	< 0.1%
5479.13	1	< 0.1%
5284.04	1	< 0.1%
5230.81	1	< 0.1%
5162.29	1	< 0.1%
5145	2	< 0.1%
5098.1	1	< 0.1%

Interactions

Correlations

	id	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	line item insurance (usd)
id	1.000	-0.083	0.192	0.136	-0.169	-0.073	0.104
unit of measure (per pack)	-0.083	1.000	-0.151	-0.129	0.097	-0.103	-0.132
line item quantity	0.192	-0.151	1.000	0.839	-0.134	-0.052	0.799
line item value	0.136	-0.129	0.839	1.000	-0.019	-0.020	0.961
pack price	-0.169	0.097	-0.134	-0.019	1.000	0.250	-0.015
unit price	-0.073	-0.103	-0.052	-0.020	0.250	1.000	-0.021
line item insurance (usd)	0.104	-0.132	0.799	0.961	-0.015	-0.021	1.000

	id	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	line item insurance (usd)
id	1.000	-0.057	0.265	0.143	-0.280	-0.224	0.124
unit of measure (per pack)	-0.057	1.000	-0.186	-0.140	0.054	-0.387	-0.134
line item quantity	0.265	-0.186	1.000	0.877	-0.330	-0.200	0.874
line item value	0.143	-0.140	0.877	1.000	0.131	0.200	0.995
pack price	-0.280	0.054	-0.330	0.131	1.000	0.859	0.132
unit price	-0.224	-0.387	-0.200	0.200	0.859	1.000	0.200
line item insurance (usd)	0.124	-0.134	0.874	0.995	0.132	0.200	1.000

	brand	country	dosage form	first line designation	fulfill via	id	line item insurance (usd)	line item quantity	line item value	managed by	pack price	product group	shipment mode	sub classification	unit of measure (per pack)	unit price	vendor inco term
brand	1.000	0.199	0.515	0.245	0.507	0.206	0.023	0.000	0.000	0.163	0.796	0.781	0.216	0.647	0.587	0.911	0.443
country	0.199	1.000	0.194	0.321	0.610	0.205	0.091	0.062	0.073	0.098	0.181	0.313	0.548	0.310	0.154	0.121	0.441
dosage form	0.515	0.194	1.000	0.230	0.476	0.171	0.093	0.081	0.089	0.019	0.095	0.653	0.239	0.825	0.546	0.126	0.288
first line designation	0.245	0.321	0.230	1.000	0.099	0.110	0.072	0.032	0.050	0.099	0.066	0.192	0.241	0.207	0.036	0.050	0.309
fulfill via	0.507	0.610	0.476	0.099	1.000	0.884	0.118	0.137	0.128	0.078	0.081	0.385	0.380	0.394	0.058	0.078	1.000
id	0.206	0.205	0.171	0.110	0.884	1.000	0.124	0.265	0.143	0.067	-0.280	0.187	0.261	0.170	-0.057	-0.224	0.338
line item insurance (usd)	0.023	0.091	0.093	0.072	0.118	0.124	1.000	0.874	0.995	0.000	0.132	0.023	0.149	0.073	-0.134	0.200	0.040
line item quantity	0.000	0.062	0.081	0.032	0.137	0.265	0.874	1.000	0.877	0.000	-0.330	0.062	0.197	0.088	-0.186	-0.200	0.054
line item value	0.000	0.073	0.089	0.050	0.128	0.143	0.995	0.877	1.000	0.000	0.131	0.018	0.135	0.062	-0.140	0.200	0.042
managed by	0.163	0.098	0.019	0.099	0.078	0.067	0.000	0.000	0.000	1.000	0.075	0.018	0.068	0.018	0.000	0.000	0.105
pack price	0.796	0.181	0.095	0.066	0.081	-0.280	0.132	-0.330	0.131	0.075	1.000	0.094	0.039	0.099	0.054	0.859	0.069
product group	0.781	0.313	0.653	0.192	0.385	0.187	0.023	0.062	0.018	0.018	0.094	1.000	0.192	0.866	0.615	0.118	0.322
shipment mode	0.216	0.548	0.239	0.241	0.380	0.261	0.149	0.197	0.135	0.068	0.039	0.192	1.000	0.200	0.058	0.058	0.380
sub classification	0.647	0.310	0.825	0.207	0.394	0.170	0.073	0.088	0.062	0.018	0.099	0.866	0.200	1.000	0.573	0.130	0.284
unit of measure (per pack)	0.587	0.154	0.546	0.036	0.058	-0.057	-0.134	-0.186	-0.140	0.000	0.054	0.615	0.058	0.573	1.000	-0.387	0.159
unit price	0.911	0.121	0.126	0.050	0.078	-0.224	0.200	-0.200	0.200	0.000	0.859	0.118	0.058	0.130	-0.387	1.000	0.072
vendor inco term	0.443	0.441	0.288	0.309	1.000	0.338	0.040	0.054	0.042	0.105	0.069	0.322	0.380	0.284	0.159	0.072	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	id	project code	pq #	po / so #	asn/dn #	country	managed by	fulfill via	vendor inco term	shipment mode	pq first sent to client date	po sent to vendor date	scheduled delivery date	delivered to client date	delivery recorded date	product group	sub classification	vendor	item description	molecule/test type	brand	dosage	dosage form	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	manufacturing site	first line designation	weight (kilograms)	freight cost (usd)	line item insurance (usd)
0	1	100-CI-T01	Pre-PQ Process	SCMS-4	ASN-8	Côte d'Ivoire	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	2-Jun-06	2-Jun-06	2-Jun-06	HRDT	HIV test	RANBAXY Fine Chemicals LTD.	HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests	HIV, Reveal G3 Rapid HIV-1 Antibody Test	Reveal	NaN	Test kit	30	19	551.00	29.00	0.97	Ranbaxy Fine Chemicals LTD	True	13	780.34	NaN
1	3	108-VN-T01	Pre-PQ Process	SCMS-13	ASN-85	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	14-Nov-06	14-Nov-06	14-Nov-06	ARV	Pediatric	Aurobindo Pharma Limited	Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml	Nevirapine	Generic	10mg/ml	Oral suspension	240	1000	6200.00	6.20	0.03	Aurobindo Unit III, India	True	358	4521.5	NaN
2	4	100-CI-T01	Pre-PQ Process	SCMS-20	ASN-14	Côte d'Ivoire	PMO - US	Direct Drop	FCA	Air	Pre-PQ Process	Date Not Captured	27-Aug-06	27-Aug-06	27-Aug-06	HRDT	HIV test	Abbott GmbH & Co. KG	HIV 1/2, Determine Complete HIV Kit, 100 Tests	HIV 1/2, Determine Complete HIV Kit	Determine	NaN	Test kit	100	500	40000.00	80.00	0.80	ABBVIE GmbH & Co.KG Wiesbaden	True	171	1653.78	NaN
3	15	108-VN-T01	Pre-PQ Process	SCMS-78	ASN-50	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	1-Sep-06	1-Sep-06	1-Sep-06	ARV	Adult	SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED)	Lamivudine 150mg, tablets, 60 Tabs	Lamivudine	Generic	150mg	Tablet	60	31920	127360.80	3.99	0.07	Ranbaxy, Paonta Shahib, India	True	1855	16007.06	NaN
4	16	108-VN-T01	Pre-PQ Process	SCMS-81	ASN-55	Vietnam	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	11-Aug-06	11-Aug-06	11-Aug-06	ARV	Adult	Aurobindo Pharma Limited	Stavudine 30mg, capsules, 60 Caps	Stavudine	Generic	30mg	Capsule	60	38000	121600.00	3.20	0.05	Aurobindo Unit III, India	True	7590	45450.08	NaN
5	23	112-NG-T01	Pre-PQ Process	SCMS-87	ASN-57	Nigeria	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	28-Sep-06	28-Sep-06	28-Sep-06	ARV	Pediatric	Aurobindo Pharma Limited	Zidovudine 10mg/ml, oral solution, Bottle, 240 ml	Zidovudine	Generic	10mg/ml	Oral solution	240	416	2225.60	5.35	0.02	Aurobindo Unit III, India	True	504	5920.42	NaN
6	44	110-ZM-T01	Pre-PQ Process	SCMS-139	ASN-130	Zambia	PMO - US	Direct Drop	DDU	Air	Pre-PQ Process	Date Not Captured	8-Jan-07	8-Jan-07	8-Jan-07	ARV	Pediatric	MERCK SHARP & DOHME IDEA GMBH (FORMALLY MERCK SHARP & DOHME B.V.)	Efavirenz 200mg [Stocrin/Sustiva], capsule, 90 Caps	Efavirenz	Stocrin/Sustiva	200mg	Capsule	90	135	4374.00	32.40	0.36	MSD South Granville Australia	True	328	Freight Included in Commodity Cost	NaN
7	45	109-TZ-T01	Pre-PQ Process	SCMS-140	ASN-94	Tanzania	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	24-Nov-06	24-Nov-06	24-Nov-06	ARV	Adult	Aurobindo Pharma Limited	Nevirapine 200mg, tablets, 60 Tabs	Nevirapine	Generic	200mg	Tablet	60	16667	60834.55	3.65	0.06	Aurobindo Unit III, India	True	1478	6212.41	NaN
8	46	112-NG-T01	Pre-PQ Process	SCMS-156	ASN-93	Nigeria	PMO - US	Direct Drop	EXW	Air	Pre-PQ Process	Date Not Captured	7-Dec-06	7-Dec-06	7-Dec-06	ARV	Adult	Aurobindo Pharma Limited	Stavudine 30mg, capsules, 60 Caps	Stavudine	Generic	30mg	Capsule	60	273	532.35	1.95	0.03	Aurobindo Unit III, India	False	See ASN-93 (ID#:1281)	See ASN-93 (ID#:1281)	NaN
9	47	110-ZM-T01	Pre-PQ Process	SCMS-165	ASN-199	Zambia	PMO - US	Direct Drop	CIP	Air	Pre-PQ Process	11/13/2006	30-Jan-07	30-Jan-07	30-Jan-07	ARV	Adult	ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV)	Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs	Lopinavir/Ritonavir	Aluvia	200/50mg	Tablet	120	2800	115080.00	41.10	0.34	ABBVIE (Abbott) St. P'burg USA	True	643	Freight Included in Commodity Cost	NaN

	id	project code	pq #	po / so #	asn/dn #	country	managed by	fulfill via	vendor inco term	shipment mode	pq first sent to client date	po sent to vendor date	scheduled delivery date	delivered to client date	delivery recorded date	product group	sub classification	vendor	item description	molecule/test type	brand	dosage	dosage form	unit of measure (per pack)	line item quantity	line item value	pack price	unit price	manufacturing site	first line designation	weight (kilograms)	freight cost (usd)	line item insurance (usd)
10314	86813	151-NG-T30	FPQ-14989	SO-51422	DN-4274	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	9/19/2014	N/A - From RDC	30-Jun-15	15-May-15	22-May-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	10340	37224.00	3.60	0.06	Mylan (formerly Matrix) Nashik	False	See DN-4274 (ID#:84472)	See DN-4274 (ID#:84472)	38.27
10315	86814	151-NG-T30	FPQ-14989	SO-51424	DN-4276	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	9/19/2014	N/A - From RDC	30-Jun-15	15-May-15	22-May-15	ARV	Adult	SCMS from RDC	Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs	Lopinavir/Ritonavir	Aluvia	200/50mg	Tablet	120	70000	1304800.00	18.64	0.16	ABBVIE Ludwigshafen Germany	True	15198	26180	1341.33
10316	86815	151-NG-T30	FPQ-16313	SO-51420	DN-4279	Nigeria	PMO - US	From RDC	N/A - From RDC	Air Charter	5/4/2015	N/A - From RDC	2-Jun-15	15-May-15	22-May-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	15000	97800.00	6.52	0.11	Aurobindo Unit III, India	True	1547	3410	115.11
10317	86816	151-NG-T30	FPQ-16313	SO-51440	DN-4282	Nigeria	PMO - US	From RDC	N/A - From RDC	Air	5/4/2015	N/A - From RDC	30-Jun-15	22-Jun-15	29-Jun-15	ARV	Adult	SCMS from RDC	Efavirenz 600mg, tablets, 30 Tabs	Efavirenz	Generic	600mg	Tablet	30	6724	20978.88	3.12	0.10	Strides, Bangalore, India.	False	See DN-4282 (ID#:83919)	See DN-4282 (ID#:83919)	24.69
10318	86817	103-ZW-T30	FPQ-15197	SO-50020	DN-4307	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Jul-15	15-Jul-15	20-Jul-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	205243	738874.80	3.60	0.06	Cipla, Goa, India	False	See DN-4307 (ID#:83920)	See DN-4307 (ID#:83920)	869.66
10319	86818	103-ZW-T30	FPQ-15197	SO-50020	DN-4307	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Jul-15	15-Jul-15	20-Jul-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs	Lamivudine/Nevirapine/Zidovudine	Generic	30/50/60mg	Chewable/dispersible tablet - FDC	60	166571	599655.60	3.60	0.06	Mylan, H-12 & H-13, India	False	See DN-4307 (ID#:83920)	See DN-4307 (ID#:83920)	705.79
10320	86819	104-CI-T30	FPQ-15259	SO-50102	DN-4313	Côte d'Ivoire	PMO - US	From RDC	N/A - From RDC	Truck	10/24/2014	N/A - From RDC	31-Jul-15	6-Aug-15	7-Aug-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	21072	137389.44	6.52	0.11	Hetero Unit III Hyderabad IN	False	See DN-4313 (ID#:83921)	See DN-4313 (ID#:83921)	161.71
10321	86821	110-ZM-T30	FPQ-14784	SO-49600	DN-4316	Zambia	PMO - US	From RDC	N/A - From RDC	Truck	8/12/2014	N/A - From RDC	31-Aug-15	25-Aug-15	3-Sep-15	ARV	Adult	SCMS from RDC	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate 600/300/300mg, tablets, 30 Tabs	Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate	Generic	600/300/300mg	Tablet - FDC	30	514526	5140114.74	9.99	0.33	Cipla Ltd A-42 MIDC Mahar. IN	False	Weight Captured Separately	Freight Included in Commodity Cost	5284.04
10322	86822	200-ZW-T30	FPQ-16523	SO-51680	DN-4334	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	7/1/2015	N/A - From RDC	9-Sep-15	4-Aug-15	11-Aug-15	ARV	Adult	SCMS from RDC	Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	150/300mg	Tablet - FDC	60	17465	113871.80	6.52	0.11	Mylan (formerly Matrix) Nashik	True	1392	Freight Included in Commodity Cost	134.03
10323	86823	103-ZW-T30	FPQ-15197	SO-50022	DN-4336	Zimbabwe	PMO - US	From RDC	N/A - From RDC	Truck	10/16/2014	N/A - From RDC	31-Aug-15	4-Aug-15	11-Aug-15	ARV	Pediatric	SCMS from RDC	Lamivudine/Zidovudine 30/60mg, dispersible tablets, 60 Tabs	Lamivudine/Zidovudine	Generic	30/60mg	Chewable/dispersible tablet - FDC	60	36639	72911.61	1.99	0.03	Cipla, Goa, India	False	Weight Captured Separately	Freight Included in Commodity Cost	85.82

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)